You will create each Conditional Column in Power Query Editor . Follow the Screen shots and GIF below in order to create the Conditional columns. You will do this for all 9 columns that need to be created.
Step 1.
Click on Transform data in the home tab, in the power query editor select Add Column - select Conditional Column-
New column name- .InterviewerPreparedness
Column Name- Survey Group
Operator- equals
Value- Interviewer Preparedness
Output- Under Output choose select a column from the dropdown then select Rating from the columns
then click on OK.
To change the Data Type of .InterviewerPreparedness conditional column ,Click on Home tab and in the datatype select Whole Number.
Follow the same to create all the conditional columns.
The link below provide information to create conditional columns in power query:
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Creating the Conditional Columns -Part 1 11You will create each Conditional Column in Power Query Editor . Follow the Screen shots and GIF below in order to create the Conditional columns. You will do this for all 9 columns that need to be created.
Step 1.
Click on Transform data in the home tab, in the power query editor select Add Column - select Conditional Column-
New column name- .InterviewerPreparedness
Column Name- Survey Group
Operator- equals
Value- Interviewer Preparedness
Output- Under Output choose select a column from the dropdown then select Rating from the columns
then click on OK.
To change the Data Type of .InterviewerPreparedness conditional column ,Click on Home tab and in the datatype select Whole Number.
Follow the same to create all the conditional columns.
The link below provide information to create conditional columns in power query:
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything